Create Staging Table in Staging Database and Populate the Staging Tables - Continued 10

·         Drag and Drop the ForEachLoop Container – double click and add the file path in the collections tab and add the JsonFilePath variable in the Variable mapping tab

·         Drag and drop the sequence container.

·         Drag Execute SQL Task inside the sequence container - Double Click and Add Connection manager and Write Sql Query

·         Drag and drop the Data Flow Task inside the sequence container - Double Click 

§  Drag and drop the Flat File Source and add the Flat File connection manager

§  Drag and drop the Data Conversion transformation - to convert the apprpriate Data Types

§  Drag and drop the OLEDB Destination - add the destination connection manager and select the staging table to load the data



Execute the Package in SSIS to load the Data into the Staging tables


The Staging tables are populated with the data from the Source Files